It should be simple since comments are stored with a user_id if they are created by a logged in user and if not then its set to false so all you need to do is select the post id from comments that are made by user_id bigger the zero, something like this:
function get_posts_with_loogedin_user_comments(){
global $wpdb;
$sql = "SELECT DISTINCT comment_post_ID
FROM $wpdb->comments
WHERE user_id > 0
";
$post_ids = $wpdb->get_col($sql);
if ($post_ids)
return $post_ids;
return false;
}
Related Posts:
- What is the difference between UNION and UNION ALL?
- Selecting COUNT(*) with DISTINCT
- ORA-00904: invalid identifier
- Unknown column in ‘field list’ error on MySQL Update query
- The wait operation timed out. ASP
- When should I use CROSS APPLY over INNER JOIN?
- Insert Data Into Temp Table with Query
- How to create Temp table with SELECT * INTO tempTable FROM CTE Query
- SQL SELECT WHERE field contains words
- Using group by on multiple columns
- Efficiently convert rows to columns in sql server
- Nested select statement in SQL Server
- What’s the difference between VARCHAR and CHAR?
- How to split the name string in mysql?
- How do you trouble shoot a “Data type mismatch in criteria expression” error in MS Access 2010?
- Sql Server equivalent of a COUNTIF aggregate function
- Column name or number of supplied values does not match table definition
- Inserting data into a temporary table
- How to Select Top 100 rows in Oracle?
- Simple PHP Pagination script
- CREATE VIEW must be the only statement in the batch
- ORA-12560: TNS:protocol adaptor error
- How can I select the first day of a month in SQL?
- Warning: Null value is eliminated by an aggregate or other SET operation in Aqua Data Studio
- SQL – HAVING vs. WHERE
- Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
- Oracle Apex column link from LOV values
- What’s the difference between RANK() and DENSE_RANK() functions in oracle?
- When to use “ON UPDATE CASCADE”
- MySQL combine two columns into one column
- How to SUM two fields within an SQL query
- DateTime2 vs DateTime in SQL Server
- ORA-01861: literal does not match format string
- Difference between numeric, float and decimal in SQL Server
- SQL Server Insert if not exists
- SQL Server: Invalid Column Name
- “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
- ERROR: there is no unique constraint matching given keys for referenced table “bar”
- How do I query for all dates greater than a certain date in SQL Server?
- String or binary data would be truncated. The statement has been terminated
- Error converting data type varchar to float
- How to concatenate text from multiple rows into a single text string in SQL Server
- Cast from VARCHAR to INT – MySQL
- Conversion failed when converting the varchar value ‘simple, ‘ to data type int
- postgresql: error duplicate key value violates unique constraint
- Is there a workaround for ORA-01795: maximum number of expressions in a list is 1000 error?
- ORA-06502: PL/SQL: numeric or value error: character string buffer too small
- “You tried to execute a query that does not include the specified aggregate function”
- How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?
- Insert into a MySQL table or update if exists
- How to round down to nearest integer in MySQL?
- Convert timestamp to date in Oracle SQL
- How do I reset a sequence in Oracle?
- MySQL error: key specification without a key length
- SQL: Two select statements in one query
- Update statement with inner join on Oracle
- Check if MySQL table exists without using “select from” syntax?
- mysql update column with value from another table
- Can I use multiple “with”?
- SQL Server dynamic PIVOT query?
- Incorrect syntax near ”
- MySQL: Can’t create table (errno: 150)
- Join vs. sub-query
- Alternative to except in MySQL
- What does Include() do in LINQ?
- SQL Server “cannot perform an aggregate function on an expression containing an aggregate or a subquery”, but Sybase can
- Get everything after and before certain character in SQL Server
- LEFT function in Oracle
- Arithmetic overflow error converting varchar to data type numeric. ’10’ <= 9.00
- Difference between EXISTS and IN in SQL?
- What does * mean in sql?
- INSERT VALUES WHERE NOT EXISTS
- Using union and order by clause in mysql
- Difference between `load data inpath ` and `location` in hive?
- How to implement LIMIT with SQL Server? [duplicate]
- SQLite string contains other string query
- What’s the best way to dedupe a table?
- Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF
- Moving database with phpMyAdmin
- WordPress SQL LIKE request doesn’t work for fields with special symbols
- How do I escape a table name or column name in SQL? esc_sql doesn’t do this
- WordPress database error: You have an error in your SQL syntax
- Restose content from revisions – sql query
- Better way to migrate to server?
- Inner Join user tables to select users with roles
- $wpdb->prepare with LIKE returning blank array instead of rows
- Removing posts by sql
- Why line returns are not reapply after doing esc_sql?
- WooCommerce database query : Get product category image path+name from thumbnail_id [closed]
- WordPress can I manually add columns in users table and display it in the default manage user plugin and registration form? [closed]
- Help me SELECT thumbnail from SQL and use
- Why is my insert row only inserting the final row from the loop into the database rather than just inserting one
- Search results sort order failing: set by date only
- Creating a “forum” – showing last post or last commented post
- Replace Unwanted Space in Post Content URL
- SQL to transform all email addresses in my DB in lowercase [closed]
- How to write inner join using posts_clauses?
- How to get the sum of each post with the same date
- How to dump a Microsoft SQL Server database to a SQL script?
- Deleting the MySQL database