Possible to use value statement and dual in mysql 5?

Hi, all... Does anyone know if it's possible to use a value statement in this query that uses "dual"? I need to insert a value of "hmls" for the field "mls" in the property_photos table when this query is run...     insert       into property_photos            ( photo_filename, photo_mls_number )                        select '#photolist.name#', '#listfirst(photolist.name, '_')#'       from dual      where not exists (select photo_filename       from property_photos      where photo_filename = '#photolist.name#') Thanks, Rick

I think you will find 'dual' is an oracle only thing ----- Excess quoted text cut - see Original Post for more -----

No, dual is a MySQL function, also. I just haven't found a way to use "value" statements as part of the "dual" select statement involved.  The "dual" method seems to be limited to the specific function of catching duplicates. Rick ----- Excess quoted text cut - see Original Post for more -----

I worked around the problem by just running a separate update query to change the 'mls' field value after the photos are processed. ----- Excess quoted text cut - see Original Post for more -----