en selected in string context, you're gonna get
> 'yes', which is true (it will work if one selects it in integer
> context). But using characters '0' and '1' will always work, string '0'
> is false in perl.
--
Jordan Elver
Web Developer
The InternetO
like this:
>
> SELECT * FROM table WHERE keywords REGEXP '%keyword%';
>
> If this does not work I may have the wrong string pattern, if so, do a
> search on REGEXP on the mySQL manual: http://www.mysql.com/doc/. I'm sure
> they have examples on using REGEXP.
>
If you add BINARY to the column it WILL make it case sensitive.
On Thursday 22 March 2001 22:01, you wrote:
> Hello All,
>
> I have a table with a column called "bus_name" varchar(100) which is used
> in a Business Name search form. I need to make the Business Name that is
> entered into the sear
