> Already tried that, but is 2 appears at the end of the list
> is doesn't get picked up because there is no comma at the end
> of the list
Are there spaces between the commas???
If not then
SELECT gallery_id, gallery_name
FROMgalleries
WHERE
keywords = '2'
> For example:
>
> gallery_id | gallery_name | keywords
> 1 | test | 1,2,3,4
> 2 | test2| 3,4,5,6
>
> And I won't to get all the galleries with where the have the
> keywords 2, which in this case would be record 1 or keyword 4
> which would be both record.
>
Many Thanks to Dobromir Velev,
And for those without PERL but with PHP (or prefer PHP) here is a quick and
dirty port to PHP
REMEMBER TO MAKE A BACKUP OF YOUR FILES BEFORE TESTING OR USING THIS
SCRIPT
IT IS RECOMMENDED YOU TEST THIS SCRIPT IN A NON PRODUCTION ENVIRONMENT
FIRST **
For the benefit of the list...
Marty and I corresponded off list to make sure his PHP wasn't at fault, it
wasn't!
Turns out the problem was a corrupt table or index that 'optimize table
' fixed up.
Cheers
Dean
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
> OK getting somewhere now...I have modified the code to the
> more advanced option that you suggested...I am now getting a
> return when I search by the ID but still not when I search by
> the FName or LName:
>
> Here is the html:
> * No, no error reported
>
> * What command do I type to f
> Thanks - but did not work...here is the information you
> requested. In looking at this please remember that, for
> example, there are lots of smith records in the data, but
> only one with the first name allenand there are lots of
> sarah records in the data but only one with the last na
>> I have a TBL of users and I have created a search screen where you can
type in
>> first or last name and it will retrieve the appropriate records. Here is
the statement:
>> "Select * from STUDENTS WHERE FName LIKE '%" .$_REQUEST['searchit']. "%'
>> OR LName LIKE '%" . $_REQUEST['searchit']. "
>> The problem is that in my java.sql.ResultSet.getDouble("strength")
>> a zero amount throws a number format exception.
Hi Paul,
Not a Java user so I haven't tested this.
You could try...
SELECT abs( strength ) FROM data ;
It 'might' stop the exception!
Cheers
Dean
--
MySQL General Maili
