[FX.php List] Off: Reproducing FileMaker style operators in mySQL

[Beverly Voth]

There are some similarities, but also some differences:

http://dev.mysql.com/doc/refman/5.7/en/comparison-operators.html

"..." in FMP is "BETWEEN" in MySQL

">=" the same in both. 

The above link is for the latest version of MySQL. Should you need an earlier version the page has links to them. 

Also this entire site is your "go-to" for MySQL. :)

-- sent from myPhone --
Beverly Voth
--

> On Jul 25, 2014, at 5:42 PM, jschwartz <jschwartz at exit445.com> wrote:
> 
> Folks,
> 
> We FileMaker users are spoiled in that the capability to insert comparison operators in a field search is built into the UI which extends through to the WPE.
> 
> I am migrating a FileMaker Web Publishing solution to mySQL and I don’t see that same capability being readily available.
> 
> One colleague suggested that I would need to detect, parse and rebuild the query.  I guess it’s not impossible.
> 
> I would need to detect “>”, “<“ and the “…” characters, then go from there.
> 
> 
> Seems like someone would gone this route before.
> 
> Any suggestions show to approach?
> 
> Thanks
> 
> Jonathan
> 
> 
> 
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list