Re: wildcards in the field

[Bob Ramsey]

At 03:52 AM 1/13/2004,  Harald Fuchs wrote:

SELECT *
FROM tbl
WHERE user = 'jones'
  AND '/data1/index.php' LIKE concat(path, '%');


Thanks for the tip.

Bob



======================================================================
Bob Ramsey                       Applications Development & Support II
ph:  1(319)335-9956                              187 Boyd Law Building
fax: 1(319)335-9019                  University of Iowa College of Law
mailto:[EMAIL PROTECTED]                Iowa City, IA 52242-1113
For Hardware and Software questions, call 5-9124
======================================================================
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]