\S refers to a non whitespace character.
>In the following: >select whatever from articles where textlines regexp "^\Sbingo\S$" > >what does \S means? > >py > > >----- Original Message ----- >From: "Jon Farmer" <[EMAIL PROTECTED]> >To: "Warren Vail" <[EMAIL PROTECTED]>; "Michael Hall" ><[EMAIL PROTECTED]>; "PHP List" <[EMAIL PROTECTED]> >Sent: Thursday, November 29, 2001 9:54 AM >Subject: Re: [PHP] database question > > >> Actually the sql statement you want is >> >> select whatever from articles where textlines regexp "^\Sbingo\S$" >> >> regards >> >> Jon >> -- >> Jon Farmer >> Systems Programmer, Entanet www.enta.net >> Tel 01952 428969 Mob 07763 620378 >> PGP Key available, send email with subject: Send PGP Key >> >> >> ----- Original Message ----- >> From: "Warren Vail" <[EMAIL PROTECTED]> >> To: "Michael Hall" <[EMAIL PROTECTED]>; "PHP List" >> <[EMAIL PROTECTED]> >> Sent: Thursday, November 29, 2001 2:57 PM >> Subject: RE: [PHP] database question >> >> >> Try; >> >> SELECT whatever FROM articles WHERE textlines LIKE "%searchword%" >> >> Two warnings; >> >> 1) This will force a "table scan" (the contents of each row in the entire >> table because there can be no index to support faster searching of >contents >> that float in the column) which will be very slow on a large database >(even >> a medium size one). >> 2) This will also find words that exist inside other words. (ie the word >> "ward" exists inside "toward") If you try to solve this by imbedding >blanks >> between the wildcard (%) and the text, you will probably not be able to >find >> the word at the end of a line, or just prior to a comma or period. >> >> I also believe there may be a way to make the search case insensitive, >look >> for something like a " WHERE tolower(textlines) LIKE ..." to force the >> column values to be all lower case and make sure your search values are >all >> lower case as well. >> >> Good luck, >> >> Warren Vail >> >> -----Original Message----- >> From: Michael Hall [mailto:[EMAIL PROTECTED]] >> Sent: Thursday, November 29, 2001 2:21 PM >> To: PHP List >> Subject: [PHP] database question >> >> >> How can I search a MySQL database field that contains sentences (VARCHAR >> datatype) or entire texts (TEXT datatype) for single words? >> >> Let's say I want to search 100 articles stored in a database field as TEXT >> for the word "bingo", is there any SQL or PHP way of doing that? >> >> Mick >> >> -- >> ################################ >> Michael Hall >> [EMAIL PROTECTED] >> [EMAIL PROTECTED] >> http://openlearningcommunity.org >> >> >> >> -- >> PHP General Mailing List (http://www.php.net/) >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> To contact the list administrators, e-mail: [EMAIL PROTECTED] >> >> >> >> -- >> PHP General Mailing List (http://www.php.net/) >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> To contact the list administrators, e-mail: [EMAIL PROTECTED] >> >> >> >> -- >> PHP General Mailing List (http://www.php.net/) >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> To contact the list administrators, e-mail: [EMAIL PROTECTED] >> > > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] -- Jim Musil --------- Multimedia Programmer Nettmedia ------------- 212-629-0004 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]