Search - Joel Lipman .Com

21. Strip HTML in MySQL: / MySQL /; Just putting a note as I have spent ages looking for a solution and getting it to work in my environment. What? Need to be able to omit HTML tags in certain fields of a mySQL database. Why? ...; Created on 06 December 2011
22. MySQL Group_concat equivalent in T-SQL and Oracle: / Databases /; MySQL is just the best Unfortunately I make a living using Microsoft and Oracle products. I shouldn't say unfortunately as I don't see myself doing any other job and it beats daytime television any day. ...; Created on 28 November 2011
23. MySQL last year week month day trend periods: / MySQL /; ... since becoming an analyst, I do more at the database level now. What follows should be usable mySQL statements to get all the numbers: Yesterdays -- CURRENT: count todays SELECT COUNT(id) FROM ...; Created on 31 October 2011
24. MySQL parameters in Excel 2007 PivotTables: / MySQL /; ... Setup Windows XP Workstation ...needs to open... Excel 2007 SP2 ...with ODBC to... MySQL v5+ ...hosting database... ActivityLog ...contains activity, staffID, resourceID, ...; Created on 24 August 2011
25. Inserting incremental weeks in MySQL: / MySQL /; Situation: I have a silly database table (not mine) storing CMIS Facility week numbers and their starting dates. For those of you unfamiliar with this system, the reason week numbers are different ...; Created on 15 April 2011
26. PHP & MySQL Search Engine: / Personal Home Page /; ... for MySQL regular expressions function search_escape_rlike($string){ return preg_replace("/([.\[\]*^\$])/", '\\\$1', $string); } # function to list terms into list of regular expressions # ...; Created on 09 March 2011
27. MySQL: Find records in one table that are not in another.: / MySQL /; The Why So I find myself writing increasingly complex SQL scripts and it's at the stage where we need to optimize the queries because some scripts are noticeably slow (as observed by the customer...) ...; Created on 25 February 2011
28. Merge the content of two similar tables in MySQL: / MySQL /; ... In MySQL, I only know how to do this with a UNION ALL clause. Scenario: I have a Joomla module which should take the keywords from a specified number of different but similar tables. I'm looking ...; Created on 11 January 2011
29. Accessing a MySQL Database with Business Intelligence Development Studio: / MySQL /; Well I tried the SQL Server Management Studio solution to connect to a MySQL database then lost my way wondering what was I trying to achieve? I've written this article because this is how I connected ...; Created on 05 January 2011
30. MySQL Commands to display all columns: / MySQL /; The scenario is that I wanted a PHP/MySQL extension created which needs to launch a query to find all columns across the tables of the local database which had valid content to extract keywords from. ...; Created on 28 October 2010
31. UTF8 Unicode PHP MySQL for International Characters: / Personal Home Page /; ... a MySQL database and display the caracters as intended with UTF8. I tried enough extensions and forum solutions, and although these changes would have an effect on the module (such as take away ...; Created on 22 October 2010
32. MySQL Oracle equivalents: / Databases /; The title of this article implies something rather odd and upcoming considering that Sun Microsystems bought MySQL and Oracle bought Sun. But in fact, this is just a quick list of some regular commands ...; Created on 27 September 2010
33. Search and Replace in a MySQL Database: / MySQL /; ... sat there with phpMyAdmin or a MySQL Administration Tool (like Navicat or SQLYog), and still there at night editing each field so that it displays correctly... well that's usually me. Found it a bit boring ...; Created on 17 March 2010
34. Increment a column in MySQL using the UPDATE query: / MySQL /; Suppose you have a column in your table that you use as a counter (storing the value of the counter - eg. times an article has been displayed). Basically what I used to do is something similar to the ...; Created on 18 February 2010
35. MySQL Data Type Reference Table: / MySQL /; A data type reference table. If you're designing a database then you don't need me to tell you what this is. My personal opinion is to always try to use the minimal type and length of the value required. ...; Created on 15 February 2010
36. Database Error: Unable to connect to the database: Could not connect to MySQL: / MySQL /; ... sure everything was OK. Basically after I use my website (using the default Joomla welcome template with NO modifications whatsoever) I start to get the "cannot connect to MYSQL." I contacted ...; Created on 25 September 2009
37. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... MySQL all of which have various ways of escaping the ampersand (except for MySQL which doesn't need to and in my opinion is the best SQL). Regular expression reminder (do not use): v_SearchName ...; Created on 28 August 2020
38. PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !: / Personal Home Page /; ... The solution above was as easy as that. Here are a number of other things I tried first: mysql_set_charset(): No iconv(): No htmlentities(): No preg_replace_callback(): No sxe(): No $xml ...; Created on 02 August 2016
39. Trim values along with the tab: / MySQL /; What? A quick article on how to trim in MySQL along with getting rid of any leading or trailing tab characters. Why? I use MS Excel for organizing data and then converting to MySQL commands. ...; Created on 13 June 2016
40. Convert foreign characters to English alphabet: / MySQL /; What? A quick article showing my MySQL statement when I want to remove all the accents from foreign characters and return the English equivalent. Why? A content management system (CMS) that I' ...; Created on 13 June 2016