query database using an outside variable

I need to query a table (TABLE1) based on the value of an element in an XML (element email address gets stored in a variable say, EMAIL1). How do I do this query? something like SELECT * FROM leads where (email matching the variable) -- View this message in context:

Re: MS SQL emulator for MySQL in order to support MS Project Server, Sharepoint...

On Thursday 14 February 2008 01:21:31 Jacob, Raymond A Jr wrote: I apologize for asking this question. I am somewhat confused by Microsoft's Licensing and I personally can not justify to senior management why MS SQL should be procured instead of procuring software more urgent requirements. I

Maria Engine and AMD and 5.1.23 binary version

Hi All, Is there any plan to release a binary version for mysql-5.1.23-maria-alpha for Linux 64 for AMD ? Thanks in advance for your help, Mariella Looking for last minute shopping deals? Find them

Master Thesis

Hi All, Am currently doing my master degree and i want to contribute to MySQL. I am planning to make my thesis in MySQL query performance and enhancing it. Can you advice me from where should I start and if this idea is great or I shouldn't waste my time on it? Regards, Haitham Kaddoura

select unique ?

Hello, I don't know if it is possible to do this with mysql alone ... Here goes : I've got a database list which is like to following : Num | Name| Colour --- 1 | Harry | Red 2 | Tom | Blue 3

Re: select unique ?

SELECT DISTINCT Colour FROM tablename Peter On 14/02/2008, Richard [EMAIL PROTECTED] wrote: Hello, I don't know if it is possible to do this with mysql alone ... Here goes : I've got a database list which is like to following : Num | Name| Colour

Re: Maria Engine and AMD and 5.1.23 binary version

Hi! On Feb 14, Mariella Petrini wrote: Hi All, Is there any plan to release a binary version for mysql-5.1.23-maria-alpha for Linux 64 for AMD ? Yes. Regards / Mit vielen Grüssen, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] /

Re: select unique ?

Try: SELECT DISTINCT Colour FROM table; Or, if you want to do it correctly: SELECT Colour FROM table GROUP BY color; Richard wrote: Hello, I don't know if it is possible to do this with mysql alone ... Here goes : I've got a database list which is like to following : Num|Name|

Re: Maria Engine and AMD and 5.1.23 binary version

Hi, Do you know an approximate date ? Thanks, Mariella --- Sergei Golubchik [EMAIL PROTECTED] wrote: Hi! On Feb 14, Mariella Petrini wrote: Hi All, Is there any plan to release a binary version for mysql-5.1.23-maria-alpha for Linux 64 for AMD ? Yes. Regards / Mit vielen

Re: MySQL 5.1.23-rc compiled and max open files

Hi ALL, I have compiled MySLQ 5.1.23-rc for Linux 64bit ./configure CC=gcc CFLAGS=-DBIG_JOINS=1 -O3 CXX=g++ CXXFLAGS=-DBIG_JOINS=1 -felide-constructors -fno-exceptions -fno-rtti -O3 --prefix=/app/mysql-5.1.23-rc --localstatedir=/app/mysql-5.1.23-rc/data --libexecdir=/app/mysql-5.1.23-rc/bin

Re: view irregularities

Shawn, On Feb 13, 2008, at 9:12 AM, Shawn Green wrote: Lev Lvovsky wrote: I'm running into a difficult to reproduce problem with a view which is similar to the following: CREATE TABLE Common ( COMMON_ID INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, COMMON_NAME VARCHAR(50),

Best Way?

If I have (2) tables. Like GROUP , CODE GRP1, AA GRP1, AB GRP1, AC GRP2, BA GRP2, BB GRP2, BC And; USER , UCODE ME, AA ME, AC YOU, AA What's the best way to query to find out if ME has all codes in either of the groups? In other words, I want to know if I have all