Register Advertise with usHelp Desk Today's Posts Search

Showing results 1 to 2 of 2
Search took 0.14 seconds.
Search: Posts Made By: Dan Grossman
Forum: Programming 19th February 2013, 11:03 AM
Replies: 5
Views: 649
Posted By Dan Grossman
Re: Help with simple MySQL Query

It's not in fact wrong at all. MySQL needs a boolean to evaluate the WHERE clause of the query, and coercing the integer return value of INSTR will have the desired result. INSTR returns 0 if the...
Forum: Programming 17th February 2013, 02:16 PM
Replies: 5
Views: 649
Posted By Dan Grossman
Re: Help with simple MySQL Query

INSTR('title', '21.01') looks for the string '21.01' in the string 'title'. That substring does not appear, so the query can never match any rows so none are even checked.

What you meant to write...
Showing results 1 to 2 of 2

 
Forum Jump


All times are GMT -6. The time now is 01:03 PM.