Urgent Need Answer (sql prob) :S

[FrozNic]

k, substr pulls out a certain part of a var in php, i need to know if there's some sort of function you can use in mysql to pull out a certain part of a variable in a sql query because i don't think substr works... thanks!

[Sxooter]

substring() should work.

[abnfire]

you can use like statment in queries.
example:

// get name from any place of the field
select *
from table
where field like '%name%'

// get name from the begning of the string in the field
select *
from table
where field like 'name%'

// get name from end of the string in the field
select *
from table
where field like '%name'