It's ugly, but this should work:
SELECT * FROM table where numbers LIKE '8,%' or numbers LIKE '%,8,%' or
numbers LIKE '%,8'
-- B
- Original Message -
From: Highviews highvi...@gmail.com
To: mysql@lists.mysql.com
Sent: Monday, July 06, 2009 6:31 PM
Subject: How to use LIKE for
Hi!
I'm getting a lot of pushback on using mysql for full-text searching on over
30,000,000 documents. It's starting to slow down when using more than 10-15
keywords. Is there an alternative anyone is using?
I don't want to replace the database, but I do need to speed up the keyword
search.
I have a table that holds attributes for users. This is the structure:
TABLE properties (
id int(11) NOT NULL,
userid int(11) NOT NULL,
attrType int(11) NOT NULL,
attrValue text NOT NULL,
FULLTEXT KEY propValue (propValue)
) TYPE=MyISAM;
The table is used to find people based on
Does anyone know if there's a maximum query length in mysql 4.1.x?
Thanks!
Does anyone know if there Is there a limit on the number/length of terms using
match against(terms)?
Thanks!
-- Avi
I've used the exportSQL script
(http://www.rot13.org/~dpavlin/projects/sql/exportSQL3.txt) to dump tables
out of Access into a file that can be imported by mySQL. Since a lot of my
work is porting Access apps to web apps, it comes in very handy.
I've also written a really simple VB script that
Is there a limit on the expression length in a full text search? I have a
situations where users might want to use over 100 words in a full-text search.
(Yes, it's ridiculous.)
Thanks in advance!
-- Avi
