Re: [PHP-DB] Re: Yes or No

2001-10-02 Thread Jordan Elver
). But using characters '0' and '1' will always work, string '0' is false in perl. -- Jordan Elver Web Developer The InternetOne UK Ltd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: [PHP-DB] Searching MySQL using LIKE

2001-09-21 Thread Jordan Elver
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. Good Luck. -Original Message- From: Jordan Elver [mailto:[EMAIL PROTECTED

Re: Case Sensitive??

2001-03-22 Thread Jordan Elver
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 search