[nycphp-talk] MySQL WHERE clause question
jsiegel1 at optonline.net
Fri May 9 09:21:10 EDT 2003
What's the difference between "SELECT * FROM `table` WHERE `column`
and using this - "DE_sDescription LIKE 'ford %' OR DE_sDescription LIKE
'% ford' OR DE_sDescription LIKE '% ford %'"
In this case of the former (the REGEXP) it would seem that if "ford" is
the first word in the text it would not pick it up since there is no
blank/space before "ford" at the beginning of the text.
Is this correct?
Or...in terms of speed, would it be better to use the REGEXP expression
in the same way I'm using the "%" wildcard? (that is...with the
different variations of blanks).
More information about the talk