RE: select command with a search?

2004-04-27 Thread Christopher Lyon
Thank you, That did the trick. > -Original Message- > From: Egor Egorov [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 27, 2004 12:17 AM > To: [EMAIL PROTECTED] > Subject: Re: select command with a search? > > "Christopher Lyon" <[EMAIL PROTECTED

select command with a search?

2004-04-26 Thread Christopher Lyon
I want to be able to search for specific text in a field and return the results for those rows. What is the best way to go about it? Do I use the regex stuff or match? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

RE: Can we crypt passwords on MySQL

2003-06-19 Thread Christopher Lyon
Technically MD5/SHA1 are hashing algorithms and shouldn't be confused with encryption algorithms like DES, 3DES or AES. From the looks of the document link you gave us it seems that AES_ENCRYT is the way to go if you want to encrypt the data. So the command would look something like this: INSER

RE: sql query using select and row functions

2003-01-29 Thread Christopher Lyon
Thank you all for your help. I think that is all I need to do is select it by row. > -Original Message- > From: R. Hannes Niedner [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 28, 2003 2:02 PM > To: Christopher Lyon; MySQL Mailinglist > Subject: Re: sql query using

RE: sql query using select and row functions

2003-01-28 Thread Christopher Lyon
I would think they would be the same no? It turns out in the database that they are the same. > -Original Message- > From: Victor Pendleton [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 28, 2003 12:23 PM > To: Christopher Lyon; [EMAIL PROTECTED] > Subject: RE:

sql query using select and row functions

2003-01-28 Thread Christopher Lyon
I am trying to do an sql query and am trying to select the last x rows from the database. I see the limit function but that seems like that is from the first row down. I want to start from the last row to the first row. So, selecting the last 5 rows for instance? Can this be done? -