Mailing List Archive
Back to the month index |
Back to the list index
|
|
Back to the month index |
Back to the list index
|
Brian Candler (B.Candler@pobox.com)
Mon, 27 Jan 1997 12:35:03 +0000 (GMT)
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
- Next message: Justin Subert: "Re: [mSQL] mSQL from chroot'd httpd Server"
- Previous message: Toru Okumura: "[mSQL] Question about TCP_PORT number..."
- Next in thread: Marcos Manhaes Marins: "Re: [mSQL] Parsing all digits to [HIGHlow] case to always FIND !"
From: Brian Candler <B.Candler@pobox.com> Message-Id: <199701271235.MAA00616@gazebo.candler.co.uk> Subject: Re: [mSQL] Parsing all digits to [HIGHlow] case to always FIND ! Date: Mon, 27 Jan 1997 12:35:03 +0000 (GMT)> Is there a LITE patch or anything like that, making automatically conversion
> below?
>
> <! msql if
>
> $keyword = jose =====> then $keywordnew= [Jj][Oo][Ss][Ee] >
>
> <! msql fi>
>
> <! msql select "foofields from footable where speciffield like
> '%$keywordnew%'">
You can use CLIKE instead of LIKE (case-insensitive LIKE, mSQL 2.0 feature)
If you want to use regular expressions such as [Jj][Oo][Ss][Ee] then you
will have to use RLIKE instead of LIKE in mSQL 2.0
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!