yeah good call on a type it should of been \s not \S -- 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: "Jim Musil" <[EMAIL PROTECTED]> To: "py" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, November 29, 2001 10:56 PM Subject: Re: [PHP] database question > \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] > -- 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]