Well,
you can save all data encoded in the database:
http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html#function_encode
- Mike
Chris schreef:
Ratheesh K J wrote:
Hello all,
I have a requirement of maintaining some secret information in the
database. And this information
Hello everybody,
I got a small problem with ordering on en ENUM field. The values in this
field are:
- to be started
- started
- finished
- canceled
And i want to order on this field, but in the direction the are above
here (and not alpabetically).
Is that possible?
- Mike
--
Medusa,
on.
To answer your question:
ORDER BY `status` = 'to be started', `status` = 'started', `status` =
'finished', `status` = 'canceled'
Mike van Hoof wrote:
Hello everybody,
I got a small problem with ordering on en ENUM field. The values in
this field are:
- to be started
- started
- finished
Hello,
i have the following query:
SELECT DISTINCT (
Waarde
) AS bestemming
FROM xml_kenmerk
WHERE Omschrijving = 'Bestemming'
AND IF (
DatumBegin IS NOT NULL
AND DatumBegin != '-00-00', DatumBegin = CURDATE( ) , 1 =1
)
AND IF (
DatumEind IS NOT NULL
Hello, I pinned down the problem to the order by line. If i leave this
away the query is done in 0.05 seconds.
- Mike
Mike van Hoof schreef:
Hello,
i have the following query:
SELECT DISTINCT (
Waarde
) AS bestemming
FROM xml_kenmerk
WHERE Omschrijving = 'Bestemming
Hello,
i am try to make a regular expression work, but keep getting this error
message:
does anyone know how i can make it work?
The query is:
SELECT 'boer bv' REGEXP '[ b|^b](?![v$|v ])';
So it has to match each starting 'b' and all the b's pf following words.
But now followed by a v(line
Hello,
i am try to make a regular expression work, but keep getting this error
message:
does anyone know how i can make it work?
The query is:
SELECT 'boer bv' REGEXP '[ b|^b](?![v$|v ])';
So it has to match each starting 'b' and all the b's pf following words.
But now followed by a v(line
the Operators.
Try with.
SELECT 'boer bv' REGEXP '[b|^b](!?[v$|v])';
Thanks
ViSolve DB Team
- Original Message - From: Mike van Hoof [EMAIL PROTECTED]
To: mysql mysql@lists.mysql.com
Sent: Monday, January 08, 2007 1:36 PM
Subject: MYSQL REGEXP help
Hello,
i am try to make a regular
Charlie Schaubmair schreef:
Hello,
I want to do a query where I only gt the results by an numeric value:
select * from MyTable where 1 IN someFieldInMyTable
I know this query doesn't work, but maybe anyone knows what I mean.
1 can be a value betwenn 1 and 23
someFieldInMyTable is normaly
someFieldInMyTable is CONCATed to ,1,2,3,4,5,6,9,21, and over that
value the where clause is done...
Maybe it helps
Mike
Charlie Schaubmair schreef:
Hello Mike,
thx, but isn't there another way?
br
Charlie
-Ursprüngliche Nachricht-
Von: Mike van Hoof [mailto:[EMAIL PROTECTED
Sorry, query was wrong... has to be:
SELECT *, CONCAT(',',someFieldInMyTable,',') as wherefield FROM MyTable
WHERE wherefield LIKE '%,1,%'
Mike van Hoof schreef:
Hey Charlie,
maybe there is, but i don't know why... because when you do a like
query it also finds the 21 when you do a like
Renato Golin schreef:
[EMAIL PROTECTED] wrote:
How do I check two tables is it? Username and userpass are submitted
through a from and are unique
$sql = SELECT username, userpass FROM mytable, mytable2 WHERE
username = '$username' AND userpass = '$userpass';
This way you'll have an
Hello,
I am having a problem, and am hoping this is the wright list to post to.
I have a TEXT field with text in them (duh!)... this text also contains
special characters like é ß ü etc...
But when i convert the TEXT field to a BLOB field these signs are lost
and i get �
So does anyone know
Addison, Mark schreef:
From: Mike van Hoof Sent: 18 July 2006 12:18
To: Addison, Mark
Subject: Re: Converting TEXT to BLOB with special chars
Addison, Mark schreef:
From: Mike van Hoof Sent: 18 July 2006 10:49
Hello,
I am having
Chris Sansom schreef:
At 13:40 +0200 18/7/06, Mike van Hoof wrote:
Well.. gonna try some text-converting in php then...
And yeah, it really needs to be a blob field... not my choice, but we
got a CMS which operates on field types from MySQL... and a blob
field wil generate an WYSIWYG field
15 matches
Mail list logo